SELECT 'sqlserver' AS dbms_type_name,
       SERVERPROPERTY('ServerName') AS dbms_name,
       TABLE_CATALOG,
       TABLE_SCHEMA,
       TABLE_NAME,
       COLUMN_NAME,
       ORDINAL_POSITION,
       COLUMN_DEFAULT,
       columnproperty(object_id(TABLE_NAME), COLUMN_NAME, 'isidentity') AS IS_IDENTITY,
       IS_NULLABLE,
       DATA_TYPE,
       CHARACTER_MAXIMUM_LENGTH,
       CHARACTER_OCTET_LENGTH,
       NUMERIC_PRECISION,
       NUMERIC_PRECISION_RADIX,
       NUMERIC_SCALE,
       DATETIME_PRECISION,
       CHARACTER_SET_CATALOG,
       CHARACTER_SET_SCHEMA,
       CHARACTER_SET_NAME,
       COLLATION_CATALOG,
       COLLATION_SCHEMA,
       COLLATION_NAME,
       DOMAIN_CATALOG,
       DOMAIN_SCHEMA,
       DOMAIN_NAME,
       getdate() AS LOAD_DTM
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME NOT IN ('dtproperties', 'sysdiagrams')
      AND OBJECTPROPERTY(OBJECT_ID('' + TABLE_SCHEMA + '.' + TABLE_NAME + ''), 'ismsshipped') = 0
